package com.hos.db.create.art;

/**
 * 文章
 * Created by guom on 2018/10/15.
 */
public class ArticleTable {
    public static String tableName = "articles";
    public static String tableArtId = "art_id";//文章id
    public static String tableArtTitle = "art_title";// 文章标题
    public static String tableArtImgCover = "art_img_cover";// 文章封面
    public static String tableArtContent = "art_content";// 文章内容
    public static String tableArtOwner = "art_owner";// 文章所有者
    public static String tableArtOwnerId = "art_owner_id";// 文章所有者id
    public static String tableArtAuthor = "art_author";// 文章作者
    public static String tableArtCreateTime = "art_create_time";// 文章创建时间
    public static String tableArtUpdateTime = "art_update_time";// 文章修改时间
     public static String tableArtRead = "art_read";// 文章阅读数量
    public static String tableArtLike = "art_like";// 文章点赞数量
    //状态 1：审核状态 2：审核通过状态
    public static String tableArtState = "art_state";
    //状态 1:上架 2：下架
    public static String tableArtIssue = "art_issue";
    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableArtId + "  varchar(200) primary key, "//主键
            + tableArtTitle + " varchar(200), "
            + tableArtImgCover + " varchar(200), "
            + tableArtContent + " longText,"
            + tableArtAuthor + " varchar(100), "
            + tableArtOwner + " varchar(100), "
            + tableArtOwnerId + " varchar(100), "
            + tableArtCreateTime + " datetime, "
            + tableArtUpdateTime + " datetime, "
            + tableArtRead + " int, "
            + tableArtLike + " int, "
            + tableArtIssue + " int, "
            + tableArtState + " int "
            + "); ";

}
